Ina Koys
Author
Description
Too often, users need to perform the same tasks again and again. It's not only boring, it takes up the time that could be used differently!
In this book, you will learn how to do less typing, how Excel can insert formattings and calculations for you, how to establish best relationships between cells, how to adjust table data, that is provided in a less than perfect way and how to arrange the Excel window in a way to find desired features quicker....
Author
Description
Often, Excel is used to evaluate given data. Which values are critical? Can I see at a glance what the development was like? Can I highlight a whole row if one column has important content? Or ask for the content of two cells, simultaneously? How do I get overview in a thick workbook? How do I get a clear and telling chart? Is there anything as clear, but not as large as a diagram? Can I ask Excel in natural language without any formula?
All these...
Author
Description
You're working with Excel since long, but would like some fresh inspiration? You had an Excel training 15 years ago and wonder what all these new buttons could do for you? Then, this book is for you!
We'll be looking at all new topics from Excel 2007 onwards: Matrix operations, Flash Fill, Conditional Formatting, Sparklines, new formulas and much more. All explained using clear examples, suitable for normal users and insiders.
Author
Description
Nope, it won't make you a coffee right now. But Outlook can write, sort and tag your mail, find lost items, maybe throw away stuff instantly or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
Author
Description
Nobody intends to make mistakes. Still, they happen. Sometimes users may not be aware of requirements or make typos. What begins as a small error, later leads to unnecessary work that costs time, money, and nerves. Here, you'll learn how to guide users in a way that makes errors less likely or even impossible. Or to inform them on input what's required.
In other cases, you may want to prepare data for decision making in a way that one does not need...
Author
Description
To explain complex context and relations, there is a tool already on each office workplace: PowerPoint. But many users are not aware of what it can really achieve: not only record anything of what one does on the screen-it also can do videos with intricate animations. Elements can be displayed or hidden, created step by step or morph one to another. The audience will focus on the subject, the message is clear and the larger context will be understood.
This...
Author
Description
Excel can take large data sets. But getting hold of required data can be tricky. Here, different possibilities are explained: The filter and the VLOOKUP() which are often heard of, but not really mastered. But there are more options like the Advanced filter, IF(), Database functions and the new, cutting-edge ones like SWITCH() and the brand new, very convenient XLOOKUP().
All are explained with examples and their specific benefits and downsides.
Author
Description
To keep information snippets in a notebook that can't be lost, that always stays up to date, that does not get dog-ears, can reach any size and takes texts, pictures, videos and sounds, shares and finds them quickly-that would be great! You have such a notebook in Windows 10, but only few use it. If you want to make it communicate with Outlook, take Office OneNote to unfold the whole potential of co-operation. There are only two types of people: the...
Author
Description
Nope, it won't make you a coffee right now. But Outlook can write, sort and tag your mail, find lost items, maybe throw away stuff instantly or re-present it at the time you find it suitable. More than that, Outlook can organize appointments, deliver route planning, present pictures of your contacts and much more.
Author
Description
Long and structured texts can be tricky. Not only regarding the technical content, also regarding layout and usability. Still, everything can integrate smoothly and look professional, if everything is properly prepared.
Here, we are looking at all the parts required for technical and scientific texts: Styles, figures, tables of content, covers and oversized items to be printed crosswise. Additionally, ways to co-operate and meanwhile keep track of...
Author
Description
In today's offices, much time is spent finding and structuring information in given data. Pivot Tables and Charts are the tool of choice to get it done. Their result often looks impressive, making people think it takes tremendous skills setting them up. It doesn't! They're easy, if only you know what result you're looking for.
In this booklet you learn everything to transform a simple Excel list to a telling Pivot Table and Chart!
Author
Description
The new office package is continuously changing. New features are supplied frequently and provide new possibilities to users and administrators alike. This booklet supplies all novelties in Word, Excel, Outlook and PowerPoint-and entirely the novelties. It makes it easy for you to make up your mind what's in for you and what new possibilities will be at your disposal. You remain on top of the game!